Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 5010 |
| Missing cells | 991 |
| Missing cells (%) | 0.9% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 5.2 MiB |
| Average record size in memory | 1.1 KiB |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 10 |
| Text | 4 |
| Numeric | 7 |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
NetAmount is highly overall correlated with QuantitySold and 1 other fields | High correlation |
ProductCategory is highly overall correlated with ProductName and 2 other fields | High correlation |
ProductName is highly overall correlated with ProductCategory and 2 other fields | High correlation |
ProductPrice is highly overall correlated with ProductCategory and 2 other fields | High correlation |
ProductSubCategory is highly overall correlated with ProductCategory and 2 other fields | High correlation |
QuantitySold is highly overall correlated with NetAmount and 1 other fields | High correlation |
StockOnHand is highly overall correlated with StockReceived | High correlation |
StockReceived is highly overall correlated with StockOnHand and 1 other fields | High correlation |
StockSold is highly overall correlated with StockReceived | High correlation |
SupplierContact is highly overall correlated with SupplierLocation and 1 other fields | High correlation |
SupplierLocation is highly overall correlated with SupplierContact and 1 other fields | High correlation |
SupplierName is highly overall correlated with SupplierContact and 1 other fields | High correlation |
TotalAmount is highly overall correlated with NetAmount and 1 other fields | High correlation |
CustomerEmail has 507 (10.1%) missing values | Missing |
SupplierContact has 484 (9.7%) missing values | Missing |
Reproduction
| Analysis started | 2024-12-20 14:45:51.191513 |
|---|---|
| Analysis finished | 2024-12-20 14:45:56.866254 |
| Duration | 5.67 seconds |
| Software version | ydata-profiling vv4.12.1 |
| Download configuration | config.json |
Variables
Date
Date
| Distinct | 729 |
|---|---|
| Distinct (%) | 14.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.3 KiB |
| Minimum | 2021-09-28 00:00:00 |
|---|---|
| Maximum | 2023-09-28 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
ProductName
Categorical
High correlation 
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 314.2 KiB |
| NonExistentProduct | |
|---|---|
| Anthony | 251 |
| Robert | 246 |
| Wanda | 246 |
| Angela | 244 |
| Other values (16) |
Length
| Max length | 18 |
|---|---|
| Median length | 8 |
| Mean length | 7.2007984 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nathaniel |
|---|---|
| 2nd row | NonExistentProduct |
| 3rd row | Angela |
| 4th row | Amy |
| 5th row | Nathaniel |
Common Values
| Value | Count | Frequency (%) |
| NonExistentProduct | 462 | 9.2% |
| Anthony | 251 | 5.0% |
| Robert | 246 | 4.9% |
| Wanda | 246 | 4.9% |
| Angela | 244 | 4.9% |
| Fred | 240 | 4.8% |
| Shannon | 239 | 4.8% |
| Michael | 236 | 4.7% |
| Shawn | 235 | 4.7% |
| Marvin | 233 | 4.7% |
| Other values (11) | 2378 |
Length
| Value | Count | Frequency (%) |
| nonexistentproduct | 462 | 9.2% |
| anthony | 251 | 5.0% |
| robert | 246 | 4.9% |
| wanda | 246 | 4.9% |
| angela | 244 | 4.9% |
| fred | 240 | 4.8% |
| shannon | 239 | 4.8% |
| michael | 236 | 4.7% |
| shawn | 235 | 4.7% |
| marvin | 233 | 4.7% |
| Other values (11) | 2378 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4011 | 11.1% |
| n | 4000 | 11.1% |
| t | 3417 | 9.5% |
| e | 2706 | 7.5% |
| i | 2687 | 7.4% |
| h | 1843 | 5.1% |
| o | 1660 | 4.6% |
| r | 1618 | 4.5% |
| l | 1122 | 3.1% |
| m | 1057 | 2.9% |
| Other values (24) | 11955 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 36076 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 4011 | 11.1% |
| n | 4000 | 11.1% |
| t | 3417 | 9.5% |
| e | 2706 | 7.5% |
| i | 2687 | 7.4% |
| h | 1843 | 5.1% |
| o | 1660 | 4.6% |
| r | 1618 | 4.5% |
| l | 1122 | 3.1% |
| m | 1057 | 2.9% |
| Other values (24) | 11955 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 36076 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 4011 | 11.1% |
| n | 4000 | 11.1% |
| t | 3417 | 9.5% |
| e | 2706 | 7.5% |
| i | 2687 | 7.4% |
| h | 1843 | 5.1% |
| o | 1660 | 4.6% |
| r | 1618 | 4.5% |
| l | 1122 | 3.1% |
| m | 1057 | 2.9% |
| Other values (24) | 11955 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 36076 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 4011 | 11.1% |
| n | 4000 | 11.1% |
| t | 3417 | 9.5% |
| e | 2706 | 7.5% |
| i | 2687 | 7.4% |
| h | 1843 | 5.1% |
| o | 1660 | 4.6% |
| r | 1618 | 4.5% |
| l | 1122 | 3.1% |
| m | 1057 | 2.9% |
| Other values (24) | 11955 |
ProductCategory
Categorical
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 323.4 KiB |
| Electronics | |
|---|---|
| Books | |
| Toys | |
| Home & Garden | |
| InvalidCategory |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 9.0744511 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Electronics |
|---|---|
| 2nd row | Electronics |
| 3rd row | InvalidCategory |
| 4th row | Home & Garden |
| 5th row | Electronics |
Common Values
| Value | Count | Frequency (%) |
| Electronics | 1575 | |
| Books | 1098 | |
| Toys | 725 | |
| Home & Garden | 648 | |
| InvalidCategory | 516 | 10.3% |
| Clothing | 448 | 8.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| electronics | 1575 | |
| books | 1098 | |
| toys | 725 | |
| home | 648 | |
| 648 | ||
| garden | 648 | |
| invalidcategory | 516 | 8.2% |
| clothing | 448 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 6108 | |
| s | 3398 | 7.5% |
| e | 3387 | 7.5% |
| n | 3187 | 7.0% |
| c | 3150 | 6.9% |
| r | 2739 | 6.0% |
| t | 2539 | 5.6% |
| l | 2539 | 5.6% |
| i | 2539 | 5.6% |
| a | 1680 | 3.7% |
| Other values (16) | 14197 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 45463 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 6108 | |
| s | 3398 | 7.5% |
| e | 3387 | 7.5% |
| n | 3187 | 7.0% |
| c | 3150 | 6.9% |
| r | 2739 | 6.0% |
| t | 2539 | 5.6% |
| l | 2539 | 5.6% |
| i | 2539 | 5.6% |
| a | 1680 | 3.7% |
| Other values (16) | 14197 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 45463 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 6108 | |
| s | 3398 | 7.5% |
| e | 3387 | 7.5% |
| n | 3187 | 7.0% |
| c | 3150 | 6.9% |
| r | 2739 | 6.0% |
| t | 2539 | 5.6% |
| l | 2539 | 5.6% |
| i | 2539 | 5.6% |
| a | 1680 | 3.7% |
| Other values (16) | 14197 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 45463 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 6108 | |
| s | 3398 | 7.5% |
| e | 3387 | 7.5% |
| n | 3187 | 7.0% |
| c | 3150 | 6.9% |
| r | 2739 | 6.0% |
| t | 2539 | 5.6% |
| l | 2539 | 5.6% |
| i | 2539 | 5.6% |
| a | 1680 | 3.7% |
| Other values (16) | 14197 |
ProductSubCategory
Categorical
High correlation 
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 321.1 KiB |
| Headphones | |
|---|---|
| Academic | |
| Shirt | |
| Fiction | |
| Educational | |
| Other values (8) |
Length
| Max length | 15 |
|---|---|
| Median length | 11 |
| Mean length | 8.5968064 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Camera |
|---|---|
| 2nd row | Mobile |
| 3rd row | Action Figures |
| 4th row | Decor |
| 5th row | Camera |
Common Values
| Value | Count | Frequency (%) |
| Headphones | 1227 | |
| Academic | 536 | |
| Shirt | 501 | |
| Fiction | 455 | 9.1% |
| Educational | 274 | 5.5% |
| Dolls | 273 | 5.4% |
| Mobile | 272 | 5.4% |
| Action Figures | 258 | 5.1% |
| Gardening Tools | 255 | 5.1% |
| Decor | 246 | 4.9% |
| Other values (3) | 713 |
Length
| Value | Count | Frequency (%) |
| headphones | 1227 | |
| academic | 536 | |
| shirt | 501 | |
| fiction | 455 | 8.2% |
| educational | 274 | 5.0% |
| dolls | 273 | 4.9% |
| mobile | 272 | 4.9% |
| action | 258 | 4.7% |
| figures | 258 | 4.7% |
| gardening | 255 | 4.6% |
| Other values (5) | 1214 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4503 | 10.5% |
| o | 3977 | 9.2% |
| i | 3963 | 9.2% |
| n | 3423 | 7.9% |
| a | 3056 | 7.1% |
| c | 2536 | 5.9% |
| d | 2292 | 5.3% |
| s | 2013 | 4.7% |
| r | 1979 | 4.6% |
| t | 1956 | 4.5% |
| Other values (21) | 13372 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 43070 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 4503 | 10.5% |
| o | 3977 | 9.2% |
| i | 3963 | 9.2% |
| n | 3423 | 7.9% |
| a | 3056 | 7.1% |
| c | 2536 | 5.9% |
| d | 2292 | 5.3% |
| s | 2013 | 4.7% |
| r | 1979 | 4.6% |
| t | 1956 | 4.5% |
| Other values (21) | 13372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 43070 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 4503 | 10.5% |
| o | 3977 | 9.2% |
| i | 3963 | 9.2% |
| n | 3423 | 7.9% |
| a | 3056 | 7.1% |
| c | 2536 | 5.9% |
| d | 2292 | 5.3% |
| s | 2013 | 4.7% |
| r | 1979 | 4.6% |
| t | 1956 | 4.5% |
| Other values (21) | 13372 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 43070 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 4503 | 10.5% |
| o | 3977 | 9.2% |
| i | 3963 | 9.2% |
| n | 3423 | 7.9% |
| a | 3056 | 7.1% |
| c | 2536 | 5.9% |
| d | 2292 | 5.3% |
| s | 2013 | 4.7% |
| r | 1979 | 4.6% |
| t | 1956 | 4.5% |
| Other values (21) | 13372 |
ProductPrice
Categorical
High correlation 
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.8 KiB |
| InvalidPrice | |
|---|---|
| 0.01 | 274 |
| 99999.99 | 252 |
| 46.23 | 196 |
| 693.39 | 196 |
| Other values (38) |
Length
| Max length | 17 |
|---|---|
| Median length | 6 |
| Mean length | 6.498004 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.01 |
|---|---|
| 2nd row | 847.43 |
| 3rd row | 386.57 |
| 4th row | 364.01 |
| 5th row | 652.35 |
Common Values
| Value | Count | Frequency (%) |
| InvalidPrice | 449 | 9.0% |
| 0.01 | 274 | 5.5% |
| 99999.99 | 252 | 5.0% |
| 46.23 | 196 | 3.9% |
| 693.39 | 196 | 3.9% |
| 386.57 | 196 | 3.9% |
| 461.09 | 192 | 3.8% |
| 847.43 | 191 | 3.8% |
| 268.61 | 186 | 3.7% |
| 951.53 | 186 | 3.7% |
| Other values (33) | 2692 |
Length
| Value | Count | Frequency (%) |
| invalidprice | 449 | 9.0% |
| 0.01 | 274 | 5.5% |
| 99999.99 | 252 | 5.0% |
| 46.23 | 196 | 3.9% |
| 693.39 | 196 | 3.9% |
| 386.57 | 196 | 3.9% |
| 461.09 | 192 | 3.8% |
| 847.43 | 191 | 3.8% |
| 268.61 | 186 | 3.7% |
| 951.53 | 186 | 3.7% |
| Other values (33) | 2692 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 4561 | |
| 9 | 3430 | |
| 1 | 3023 | |
| 3 | 2843 | |
| 6 | 2644 | |
| 0 | 2552 | |
| 8 | 2043 | 6.3% |
| 4 | 1833 | 5.6% |
| 2 | 1808 | 5.6% |
| 5 | 1794 | 5.5% |
| Other values (12) | 6024 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32555 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 4561 | |
| 9 | 3430 | |
| 1 | 3023 | |
| 3 | 2843 | |
| 6 | 2644 | |
| 0 | 2552 | |
| 8 | 2043 | 6.3% |
| 4 | 1833 | 5.6% |
| 2 | 1808 | 5.6% |
| 5 | 1794 | 5.5% |
| Other values (12) | 6024 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32555 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 4561 | |
| 9 | 3430 | |
| 1 | 3023 | |
| 3 | 2843 | |
| 6 | 2644 | |
| 0 | 2552 | |
| 8 | 2043 | 6.3% |
| 4 | 1833 | 5.6% |
| 2 | 1808 | 5.6% |
| 5 | 1794 | 5.5% |
| Other values (12) | 6024 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32555 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 4561 | |
| 9 | 3430 | |
| 1 | 3023 | |
| 3 | 2843 | |
| 6 | 2644 | |
| 0 | 2552 | |
| 8 | 2043 | 6.3% |
| 4 | 1833 | 5.6% |
| 2 | 1808 | 5.6% |
| 5 | 1794 | 5.5% |
| Other values (12) | 6024 |
CustomerName
Text
| Distinct | 4846 |
|---|---|
| Distinct (%) | 96.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 343.9 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 24 |
| Mean length | 13.268862 |
| Min length | 7 |
Unique
| Unique | 4707 ? |
|---|---|
| Unique (%) | 94.0% |
Sample
| 1st row | Colleen Kelly |
|---|---|
| 2nd row | Joel Wright |
| 3rd row | Thomas Sawyer |
| 4th row | Tyler Gardner |
| 5th row | Meagan Peterson |
| Value | Count | Frequency (%) |
| smith | 119 | 1.2% |
| michael | 110 | 1.1% |
| johnson | 84 | 0.8% |
| james | 82 | 0.8% |
| thomas | 80 | 0.8% |
| john | 77 | 0.8% |
| jennifer | 72 | 0.7% |
| christopher | 72 | 0.7% |
| david | 66 | 0.6% |
| williams | 63 | 0.6% |
| Other values (1420) | 9437 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6188 | 9.3% |
| a | 6049 | 9.1% |
| 5252 | 7.9% | |
| n | 4930 | 7.4% |
| r | 4791 | 7.2% |
| i | 4078 | 6.1% |
| o | 3582 | 5.4% |
| l | 3388 | 5.1% |
| s | 2982 | 4.5% |
| h | 2271 | 3.4% |
| Other values (42) | 22966 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 66477 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6188 | 9.3% |
| a | 6049 | 9.1% |
| 5252 | 7.9% | |
| n | 4930 | 7.4% |
| r | 4791 | 7.2% |
| i | 4078 | 6.1% |
| o | 3582 | 5.4% |
| l | 3388 | 5.1% |
| s | 2982 | 4.5% |
| h | 2271 | 3.4% |
| Other values (42) | 22966 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 66477 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6188 | 9.3% |
| a | 6049 | 9.1% |
| 5252 | 7.9% | |
| n | 4930 | 7.4% |
| r | 4791 | 7.2% |
| i | 4078 | 6.1% |
| o | 3582 | 5.4% |
| l | 3388 | 5.1% |
| s | 2982 | 4.5% |
| h | 2271 | 3.4% |
| Other values (42) | 22966 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 66477 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6188 | 9.3% |
| a | 6049 | 9.1% |
| 5252 | 7.9% | |
| n | 4930 | 7.4% |
| r | 4791 | 7.2% |
| i | 4078 | 6.1% |
| o | 3582 | 5.4% |
| l | 3388 | 5.1% |
| s | 2982 | 4.5% |
| h | 2271 | 3.4% |
| Other values (42) | 22966 |
CustomerEmail
Text
Missing 
| Distinct | 4450 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 507 |
| Missing (%) | 10.1% |
| Memory size | 362.7 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 28 |
| Mean length | 21.849656 |
| Min length | 15 |
Unique
| Unique | 4408 ? |
|---|---|
| Unique (%) | 97.9% |
Sample
| 1st row | maryhurst@example.org |
|---|---|
| 2nd row | sandersvictoria@example.org |
| 3rd row | ospence@example.net |
| 4th row | christopherjohnson@example.com |
| 5th row | epowell@example.net |
| Value | Count | Frequency (%) |
| garciashawn@example.com | 11 | 0.2% |
| xjackson@example.net | 3 | 0.1% |
| fwilliams@example.net | 3 | 0.1% |
| taylorrobert@example.com | 2 | < 0.1% |
| ijones@example.com | 2 | < 0.1% |
| jenniferreed@example.com | 2 | < 0.1% |
| wrightjennifer@example.net | 2 | < 0.1% |
| rtaylor@example.org | 2 | < 0.1% |
| osmith@example.com | 2 | < 0.1% |
| rallen@example.org | 2 | < 0.1% |
| Other values (4440) | 4472 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 14830 | |
| a | 9158 | 9.3% |
| m | 7680 | 7.8% |
| l | 7142 | 7.3% |
| o | 5624 | 5.7% |
| r | 5230 | 5.3% |
| p | 5088 | 5.2% |
| n | 4925 | 5.0% |
| x | 4610 | 4.7% |
| @ | 4503 | 4.6% |
| Other values (28) | 29599 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 98389 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 14830 | |
| a | 9158 | 9.3% |
| m | 7680 | 7.8% |
| l | 7142 | 7.3% |
| o | 5624 | 5.7% |
| r | 5230 | 5.3% |
| p | 5088 | 5.2% |
| n | 4925 | 5.0% |
| x | 4610 | 4.7% |
| @ | 4503 | 4.6% |
| Other values (28) | 29599 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 98389 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 14830 | |
| a | 9158 | 9.3% |
| m | 7680 | 7.8% |
| l | 7142 | 7.3% |
| o | 5624 | 5.7% |
| r | 5230 | 5.3% |
| p | 5088 | 5.2% |
| n | 4925 | 5.0% |
| x | 4610 | 4.7% |
| @ | 4503 | 4.6% |
| Other values (28) | 29599 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 98389 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 14830 | |
| a | 9158 | 9.3% |
| m | 7680 | 7.8% |
| l | 7142 | 7.3% |
| o | 5624 | 5.7% |
| r | 5230 | 5.3% |
| p | 5088 | 5.2% |
| n | 4925 | 5.0% |
| x | 4610 | 4.7% |
| @ | 4503 | 4.6% |
| Other values (28) | 29599 |
CustomerAddress
Text
| Distinct | 5000 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 497.2 KiB |
Length
| Max length | 65 |
|---|---|
| Median length | 56 |
| Mean length | 44.60519 |
| Min length | 22 |
Unique
| Unique | 4999 ? |
|---|---|
| Unique (%) | 99.8% |
Sample
| 1st row | 354 Mcdowell Turnpike, Port Charles, CT 95318 |
|---|---|
| 2nd row | 24740 Fox Villages, New Tracie, MA 53038 |
| 3rd row | 769 Joe Trail, East Terri, CA 43813 |
| 4th row | 27783 Olivia Centers, Williamsmouth, AL 09809 |
| 5th row | 25357 Blackwell Locks, Andreabury, MH 27857 |
| Value | Count | Frequency (%) |
| suite | 1103 | 3.0% |
| apt | 1096 | 3.0% |
| port | 372 | 1.0% |
| box | 364 | 1.0% |
| new | 343 | 0.9% |
| south | 343 | 0.9% |
| lake | 326 | 0.9% |
| east | 320 | 0.9% |
| north | 304 | 0.8% |
| west | 299 | 0.8% |
| Other values (13437) | 32011 |
Most occurring characters
| Value | Count | Frequency (%) |
| 31871 | 14.3% | |
| e | 11462 | 5.1% |
| , | 9667 | 4.3% |
| a | 9275 | 4.2% |
| t | 8835 | 4.0% |
| r | 8212 | 3.7% |
| i | 7308 | 3.3% |
| o | 7256 | 3.2% |
| n | 6972 | 3.1% |
| s | 6018 | 2.7% |
| Other values (54) | 116596 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 223472 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 31871 | 14.3% | |
| e | 11462 | 5.1% |
| , | 9667 | 4.3% |
| a | 9275 | 4.2% |
| t | 8835 | 4.0% |
| r | 8212 | 3.7% |
| i | 7308 | 3.3% |
| o | 7256 | 3.2% |
| n | 6972 | 3.1% |
| s | 6018 | 2.7% |
| Other values (54) | 116596 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 223472 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 31871 | 14.3% | |
| e | 11462 | 5.1% |
| , | 9667 | 4.3% |
| a | 9275 | 4.2% |
| t | 8835 | 4.0% |
| r | 8212 | 3.7% |
| i | 7308 | 3.3% |
| o | 7256 | 3.2% |
| n | 6972 | 3.1% |
| s | 6018 | 2.7% |
| Other values (54) | 116596 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 223472 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 31871 | 14.3% | |
| e | 11462 | 5.1% |
| , | 9667 | 4.3% |
| a | 9275 | 4.2% |
| t | 8835 | 4.0% |
| r | 8212 | 3.7% |
| i | 7308 | 3.3% |
| o | 7256 | 3.2% |
| n | 6972 | 3.1% |
| s | 6018 | 2.7% |
| Other values (54) | 116596 |
CustomerPhone
Text
| Distinct | 5000 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 358.5 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 16.238922 |
| Min length | 10 |
Unique
| Unique | 4999 ? |
|---|---|
| Unique (%) | 99.8% |
Sample
| 1st row | 908.610.2711x8507 |
|---|---|
| 2nd row | +1-408-938-0389x952 |
| 3rd row | 001-929-516-1919x39288 |
| 4th row | 8907712983 |
| 5th row | 9999921886 |
| Value | Count | Frequency (%) |
| 449)651-5198x65597 | 11 | 0.2% |
| 001-652-348-4765x0079 | 1 | < 0.1% |
| 864-925-8941 | 1 | < 0.1% |
| 306.753.6693x620 | 1 | < 0.1% |
| 841)652-5216x95122 | 1 | < 0.1% |
| 645.998.8051x74261 | 1 | < 0.1% |
| 908.610.2711x8507 | 1 | < 0.1% |
| 1-408-938-0389x952 | 1 | < 0.1% |
| 598.250.4181 | 1 | < 0.1% |
| 972-968-0237x0312 | 1 | < 0.1% |
| Other values (4990) | 4990 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 7808 | |
| 1 | 6805 | |
| 0 | 6803 | |
| 3 | 6575 | |
| 5 | 6566 | |
| 8 | 6559 | |
| 7 | 6536 | |
| 9 | 6514 | |
| 2 | 6446 | |
| 4 | 6426 | |
| Other values (6) | 14319 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 81357 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 7808 | |
| 1 | 6805 | |
| 0 | 6803 | |
| 3 | 6575 | |
| 5 | 6566 | |
| 8 | 6559 | |
| 7 | 6536 | |
| 9 | 6514 | |
| 2 | 6446 | |
| 4 | 6426 | |
| Other values (6) | 14319 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 81357 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 7808 | |
| 1 | 6805 | |
| 0 | 6803 | |
| 3 | 6575 | |
| 5 | 6566 | |
| 8 | 6559 | |
| 7 | 6536 | |
| 9 | 6514 | |
| 2 | 6446 | |
| 4 | 6426 | |
| Other values (6) | 14319 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 81357 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 7808 | |
| 1 | 6805 | |
| 0 | 6803 | |
| 3 | 6575 | |
| 5 | 6566 | |
| 8 | 6559 | |
| 7 | 6536 | |
| 9 | 6514 | |
| 2 | 6446 | |
| 4 | 6426 | |
| Other values (6) | 14319 |
CustomerSegment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 305.1 KiB |
| Gold | |
|---|---|
| Silver | |
| Bronze |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.3245509 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Silver |
|---|---|
| 2nd row | Gold |
| 3rd row | Gold |
| 4th row | Gold |
| 5th row | Gold |
Common Values
| Value | Count | Frequency (%) |
| Gold | 1692 | |
| Silver | 1683 | |
| Bronze | 1635 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| gold | 1692 | |
| silver | 1683 | |
| bronze | 1635 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 3375 | |
| o | 3327 | |
| r | 3318 | |
| e | 3318 | |
| d | 1692 | |
| G | 1692 | |
| i | 1683 | |
| S | 1683 | |
| v | 1683 | |
| B | 1635 | |
| Other values (2) | 3270 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 26676 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 3375 | |
| o | 3327 | |
| r | 3318 | |
| e | 3318 | |
| d | 1692 | |
| G | 1692 | |
| i | 1683 | |
| S | 1683 | |
| v | 1683 | |
| B | 1635 | |
| Other values (2) | 3270 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 26676 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 3375 | |
| o | 3327 | |
| r | 3318 | |
| e | 3318 | |
| d | 1692 | |
| G | 1692 | |
| i | 1683 | |
| S | 1683 | |
| v | 1683 | |
| B | 1635 | |
| Other values (2) | 3270 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 26676 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 3375 | |
| o | 3327 | |
| r | 3318 | |
| e | 3318 | |
| d | 1692 | |
| G | 1692 | |
| i | 1683 | |
| S | 1683 | |
| v | 1683 | |
| B | 1635 | |
| Other values (2) | 3270 |
SupplierName
Categorical
High correlation 
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 364.8 KiB |
| Gilbert, Miller and Lee | 277 |
|---|---|
| Mathis, Olson and Ryan | 272 |
| Smith PLC | 272 |
| Ramirez, Hicks and Lara | 267 |
| Higgins and Sons | 263 |
| Other values (15) |
Length
| Max length | 28 |
|---|---|
| Median length | 26 |
| Mean length | 17.535928 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Rodriguez, Winters and Perez |
|---|---|
| 2nd row | Lawson-Wilkins |
| 3rd row | Lee-Miller |
| 4th row | Soto-Rivera |
| 5th row | Rodriguez, Winters and Perez |
Common Values
| Value | Count | Frequency (%) |
| Gilbert, Miller and Lee | 277 | 5.5% |
| Mathis, Olson and Ryan | 272 | 5.4% |
| Smith PLC | 272 | 5.4% |
| Ramirez, Hicks and Lara | 267 | 5.3% |
| Higgins and Sons | 263 | 5.2% |
| Rodriguez, Winters and Perez | 263 | 5.2% |
| Campos-Murillo | 262 | 5.2% |
| Lee-Miller | 256 | 5.1% |
| White and Sons | 255 | 5.1% |
| Roman-Chambers | 254 | 5.1% |
| Other values (10) | 2369 |
Length
| Value | Count | Frequency (%) |
| and | 2560 | 20.2% |
| sons | 518 | 4.1% |
| jackson | 479 | 3.8% |
| lee | 277 | 2.2% |
| miller | 277 | 2.2% |
| gilbert | 277 | 2.2% |
| mathis | 272 | 2.1% |
| ryan | 272 | 2.1% |
| olson | 272 | 2.1% |
| plc | 272 | 2.1% |
| Other values (29) | 7189 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7812 | 8.9% |
| 7655 | 8.7% | |
| n | 7283 | 8.3% |
| i | 5371 | 6.1% |
| e | 5340 | 6.1% |
| l | 5285 | 6.0% |
| r | 5244 | 6.0% |
| o | 4882 | 5.6% |
| d | 3549 | 4.0% |
| s | 3338 | 3.8% |
| Other values (29) | 32096 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87855 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 7812 | 8.9% |
| 7655 | 8.7% | |
| n | 7283 | 8.3% |
| i | 5371 | 6.1% |
| e | 5340 | 6.1% |
| l | 5285 | 6.0% |
| r | 5244 | 6.0% |
| o | 4882 | 5.6% |
| d | 3549 | 4.0% |
| s | 3338 | 3.8% |
| Other values (29) | 32096 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87855 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 7812 | 8.9% |
| 7655 | 8.7% | |
| n | 7283 | 8.3% |
| i | 5371 | 6.1% |
| e | 5340 | 6.1% |
| l | 5285 | 6.0% |
| r | 5244 | 6.0% |
| o | 4882 | 5.6% |
| d | 3549 | 4.0% |
| s | 3338 | 3.8% |
| Other values (29) | 32096 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87855 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 7812 | 8.9% |
| 7655 | 8.7% | |
| n | 7283 | 8.3% |
| i | 5371 | 6.1% |
| e | 5340 | 6.1% |
| l | 5285 | 6.0% |
| r | 5244 | 6.0% |
| o | 4882 | 5.6% |
| d | 3549 | 4.0% |
| s | 3338 | 3.8% |
| Other values (29) | 32096 |
SupplierLocation
Categorical
High correlation 
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.9 KiB |
| Lake Juanland | 277 |
|---|---|
| Herreraland | 272 |
| Lake Candiceton | 272 |
| Dustinmouth | 267 |
| West Johnbury | 263 |
| Other values (15) |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 12.250898 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Irwinhaven |
|---|---|
| 2nd row | Calderonchester |
| 3rd row | South Emilyview |
| 4th row | West Denise |
| 5th row | Irwinhaven |
Common Values
| Value | Count | Frequency (%) |
| Lake Juanland | 277 | 5.5% |
| Herreraland | 272 | 5.4% |
| Lake Candiceton | 272 | 5.4% |
| Dustinmouth | 267 | 5.3% |
| West Johnbury | 263 | 5.2% |
| Irwinhaven | 263 | 5.2% |
| Lawsontown | 262 | 5.2% |
| South Emilyview | 256 | 5.1% |
| West Scott | 255 | 5.1% |
| Dennischester | 254 | 5.1% |
| Other values (10) | 2369 |
Length
| Value | Count | Frequency (%) |
| west | 963 | 13.3% |
| lake | 549 | 7.6% |
| south | 492 | 6.8% |
| juanland | 277 | 3.8% |
| candiceton | 272 | 3.7% |
| herreraland | 272 | 3.7% |
| dustinmouth | 267 | 3.7% |
| johnbury | 263 | 3.6% |
| irwinhaven | 263 | 3.6% |
| lawsontown | 262 | 3.6% |
| Other values (14) | 3379 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7195 | 11.7% |
| n | 5576 | 9.1% |
| t | 5198 | 8.5% |
| a | 4365 | 7.1% |
| r | 4007 | 6.5% |
| o | 3998 | 6.5% |
| i | 3436 | 5.6% |
| s | 3186 | 5.2% |
| h | 2512 | 4.1% |
| 2249 | 3.7% | |
| Other values (24) | 19655 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 61377 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 7195 | 11.7% |
| n | 5576 | 9.1% |
| t | 5198 | 8.5% |
| a | 4365 | 7.1% |
| r | 4007 | 6.5% |
| o | 3998 | 6.5% |
| i | 3436 | 5.6% |
| s | 3186 | 5.2% |
| h | 2512 | 4.1% |
| 2249 | 3.7% | |
| Other values (24) | 19655 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 61377 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 7195 | 11.7% |
| n | 5576 | 9.1% |
| t | 5198 | 8.5% |
| a | 4365 | 7.1% |
| r | 4007 | 6.5% |
| o | 3998 | 6.5% |
| i | 3436 | 5.6% |
| s | 3186 | 5.2% |
| h | 2512 | 4.1% |
| 2249 | 3.7% | |
| Other values (24) | 19655 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 61377 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 7195 | 11.7% |
| n | 5576 | 9.1% |
| t | 5198 | 8.5% |
| a | 4365 | 7.1% |
| r | 4007 | 6.5% |
| o | 3998 | 6.5% |
| i | 3436 | 5.6% |
| s | 3186 | 5.2% |
| h | 2512 | 4.1% |
| 2249 | 3.7% | |
| Other values (24) | 19655 |
SupplierContact
Categorical
High correlation  Missing 
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 484 |
| Missing (%) | 9.7% |
| Memory size | 349.9 KiB |
| (906)306-1777x264 | 248 |
|---|---|
| +1-619-677-8121x28226 | 247 |
| 230-568-4141 | 240 |
| 459-301-8580 | 240 |
| 822-222-4939 | 239 |
| Other values (15) |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 15.280822 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 6538306661 |
|---|---|
| 2nd row | +1-588-750-7646 |
| 3rd row | 805-650-6257x5876 |
| 4th row | 6538306661 |
| 5th row | 805-650-6257x5876 |
Common Values
| Value | Count | Frequency (%) |
| (906)306-1777x264 | 248 | 5.0% |
| +1-619-677-8121x28226 | 247 | 4.9% |
| 230-568-4141 | 240 | 4.8% |
| 459-301-8580 | 240 | 4.8% |
| 822-222-4939 | 239 | 4.8% |
| 853-738-3918 | 238 | 4.8% |
| 6538306661 | 236 | 4.7% |
| 001-324-909-1637x2831 | 234 | 4.7% |
| +1-588-750-7646 | 232 | 4.6% |
| 288-572-7043 | 231 | 4.6% |
| Other values (10) | 2141 | |
| (Missing) | 484 | 9.7% |
Length
| Value | Count | Frequency (%) |
| 906)306-1777x264 | 248 | 5.5% |
| 1-619-677-8121x28226 | 247 | 5.5% |
| 230-568-4141 | 240 | 5.3% |
| 459-301-8580 | 240 | 5.3% |
| 822-222-4939 | 239 | 5.3% |
| 853-738-3918 | 238 | 5.3% |
| 6538306661 | 236 | 5.2% |
| 001-324-909-1637x2831 | 234 | 5.2% |
| 1-588-750-7646 | 232 | 5.1% |
| 288-572-7043 | 231 | 5.1% |
| Other values (10) | 2141 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 8354 | |
| 7 | 7779 | |
| 2 | 7039 | |
| 6 | 6548 | |
| 5 | 5741 | |
| 8 | 5650 | |
| 0 | 5392 | |
| 1 | 5292 | |
| 3 | 5248 | |
| 9 | 4387 | |
| Other values (6) | 7731 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 69161 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 8354 | |
| 7 | 7779 | |
| 2 | 7039 | |
| 6 | 6548 | |
| 5 | 5741 | |
| 8 | 5650 | |
| 0 | 5392 | |
| 1 | 5292 | |
| 3 | 5248 | |
| 9 | 4387 | |
| Other values (6) | 7731 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 69161 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 8354 | |
| 7 | 7779 | |
| 2 | 7039 | |
| 6 | 6548 | |
| 5 | 5741 | |
| 8 | 5650 | |
| 0 | 5392 | |
| 1 | 5292 | |
| 3 | 5248 | |
| 9 | 4387 | |
| Other values (6) | 7731 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 69161 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 8354 | |
| 7 | 7779 | |
| 2 | 7039 | |
| 6 | 6548 | |
| 5 | 5741 | |
| 8 | 5650 | |
| 0 | 5392 | |
| 1 | 5292 | |
| 3 | 5248 | |
| 9 | 4387 | |
| Other values (6) | 7731 |
ShipperName
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 299.5 KiB |
| Group | |
|---|---|
| and Sons | |
| LLC | |
| PLC | |
| Ltd |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 4.193014 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | and Sons |
|---|---|
| 2nd row | PLC |
| 3rd row | PLC |
| 4th row | LLC |
| 5th row | Ltd |
Common Values
| Value | Count | Frequency (%) |
| Group | 861 | |
| and Sons | 851 | |
| LLC | 846 | |
| PLC | 832 | |
| Ltd | 814 | |
| Inc | 806 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| group | 861 | |
| and | 851 | |
| sons | 851 | |
| llc | 846 | |
| plc | 832 | |
| ltd | 814 | |
| inc | 806 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 3338 | |
| n | 2508 | |
| o | 1712 | 8.1% |
| C | 1678 | 8.0% |
| d | 1665 | 7.9% |
| G | 861 | 4.1% |
| u | 861 | 4.1% |
| p | 861 | 4.1% |
| r | 861 | 4.1% |
| 851 | 4.1% | |
| Other values (7) | 5811 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21007 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 3338 | |
| n | 2508 | |
| o | 1712 | 8.1% |
| C | 1678 | 8.0% |
| d | 1665 | 7.9% |
| G | 861 | 4.1% |
| u | 861 | 4.1% |
| p | 861 | 4.1% |
| r | 861 | 4.1% |
| 851 | 4.1% | |
| Other values (7) | 5811 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21007 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 3338 | |
| n | 2508 | |
| o | 1712 | 8.1% |
| C | 1678 | 8.0% |
| d | 1665 | 7.9% |
| G | 861 | 4.1% |
| u | 861 | 4.1% |
| p | 861 | 4.1% |
| r | 861 | 4.1% |
| 851 | 4.1% | |
| Other values (7) | 5811 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21007 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 3338 | |
| n | 2508 | |
| o | 1712 | 8.1% |
| C | 1678 | 8.0% |
| d | 1665 | 7.9% |
| G | 861 | 4.1% |
| u | 861 | 4.1% |
| p | 861 | 4.1% |
| r | 861 | 4.1% |
| 851 | 4.1% | |
| Other values (7) | 5811 |
ShippingMethod
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 298.6 KiB |
| Air | |
|---|---|
| Ground | |
| Sea |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 4.0137725 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ground |
|---|---|
| 2nd row | Air |
| 3rd row | Sea |
| 4th row | Air |
| 5th row | Sea |
Common Values
| Value | Count | Frequency (%) |
| Air | 1707 | |
| Ground | 1693 | |
| Sea | 1610 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| air | 1707 | |
| ground | 1693 | |
| sea | 1610 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 3400 | |
| A | 1707 | |
| i | 1707 | |
| G | 1693 | |
| o | 1693 | |
| u | 1693 | |
| n | 1693 | |
| d | 1693 | |
| S | 1610 | |
| e | 1610 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20109 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 3400 | |
| A | 1707 | |
| i | 1707 | |
| G | 1693 | |
| o | 1693 | |
| u | 1693 | |
| n | 1693 | |
| d | 1693 | |
| S | 1610 | |
| e | 1610 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20109 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 3400 | |
| A | 1707 | |
| i | 1707 | |
| G | 1693 | |
| o | 1693 | |
| u | 1693 | |
| n | 1693 | |
| d | 1693 | |
| S | 1610 | |
| e | 1610 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20109 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 3400 | |
| A | 1707 | |
| i | 1707 | |
| G | 1693 | |
| o | 1693 | |
| u | 1693 | |
| n | 1693 | |
| d | 1693 | |
| S | 1610 | |
| e | 1610 |
QuantitySold
Real number (ℝ)
High correlation 
| Distinct | 100 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.827146 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 26 |
| median | 50 |
| Q3 | 76 |
| 95-th percentile | 95 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 28.523303 |
|---|---|
| Coefficient of variation (CV) | 0.56118247 |
| Kurtosis | -1.1823428 |
| Mean | 50.827146 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 0.00030494085 |
| Sum | 254644 |
| Variance | 813.57882 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 45 | 70 | 1.4% |
| 39 | 66 | 1.3% |
| 80 | 65 | 1.3% |
| 87 | 64 | 1.3% |
| 73 | 63 | 1.3% |
| 26 | 62 | 1.2% |
| 92 | 60 | 1.2% |
| 40 | 60 | 1.2% |
| 30 | 59 | 1.2% |
| 16 | 59 | 1.2% |
| Other values (90) | 4382 |
| Value | Count | Frequency (%) |
| 1 | 46 | |
| 2 | 44 | |
| 3 | 51 | |
| 4 | 41 | |
| 5 | 41 | |
| 6 | 47 | |
| 7 | 41 | |
| 8 | 39 | |
| 9 | 52 | |
| 10 | 48 |
| Value | Count | Frequency (%) |
| 100 | 47 | |
| 99 | 57 | |
| 98 | 42 | |
| 97 | 46 | |
| 96 | 50 | |
| 95 | 48 | |
| 94 | 52 | |
| 93 | 52 | |
| 92 | 60 | |
| 91 | 47 |
TotalAmount
Real number (ℝ)
High correlation 
| Distinct | 1848 |
|---|---|
| Distinct (%) | 36.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28851.53 |
| Minimum | 46.23 |
|---|---|
| Maximum | 99513 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 46.23 |
|---|---|
| 5-th percentile | 1546.28 |
| Q1 | 8864.13 |
| median | 23546.135 |
| Q3 | 42985.95 |
| 95-th percentile | 75624.129 |
| Maximum | 99513 |
| Range | 99466.77 |
| Interquartile range (IQR) | 34121.82 |
Descriptive statistics
| Standard deviation | 23139.578 |
|---|---|
| Coefficient of variation (CV) | 0.80202258 |
| Kurtosis | -0.20417134 |
| Mean | 28851.53 |
| Median Absolute Deviation (MAD) | 16452.715 |
| Skewness | 0.78550937 |
| Sum | 1.4454616 × 108 |
| Variance | 5.3544008 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33631.59 | 12 | 0.2% |
| 48761.37 | 9 | 0.2% |
| 76122.4 | 9 | 0.2% |
| 64590.9 | 9 | 0.2% |
| 31522.86 | 9 | 0.2% |
| 77963.56 | 8 | 0.2% |
| 44359.8 | 8 | 0.2% |
| 17472.48 | 8 | 0.2% |
| 3491.93 | 8 | 0.2% |
| 39653.74 | 7 | 0.1% |
| Other values (1838) | 4923 |
| Value | Count | Frequency (%) |
| 46.23 | 1 | < 0.1% |
| 68.01 | 1 | < 0.1% |
| 92.46 | 1 | < 0.1% |
| 138.69 | 4 | |
| 184.92 | 3 | |
| 204.03 | 2 | |
| 228.82 | 2 | |
| 231.15 | 1 | < 0.1% |
| 268.61 | 4 | |
| 272.04 | 2 |
| Value | Count | Frequency (%) |
| 99513 | 2 | < 0.1% |
| 98517.87 | 2 | < 0.1% |
| 97522.74 | 2 | < 0.1% |
| 96527.61 | 2 | < 0.1% |
| 95532.48 | 2 | < 0.1% |
| 95153 | 6 | |
| 94537.35 | 1 | < 0.1% |
| 94201.47 | 3 | |
| 93542.22 | 2 | < 0.1% |
| 93249.94 | 3 |
DiscountAmount
Real number (ℝ)
| Distinct | 4353 |
|---|---|
| Distinct (%) | 86.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 86.425236 |
| Minimum | 0.01 |
|---|---|
| Maximum | 298.11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 4.538 |
| Q1 | 25.685 |
| median | 69.345 |
| Q3 | 129.2775 |
| 95-th percentile | 228.5685 |
| Maximum | 298.11 |
| Range | 298.1 |
| Interquartile range (IQR) | 103.5925 |
Descriptive statistics
| Standard deviation | 70.574899 |
|---|---|
| Coefficient of variation (CV) | 0.8166006 |
| Kurtosis | -0.26615701 |
| Mean | 86.425236 |
| Median Absolute Deviation (MAD) | 49.605 |
| Skewness | 0.79048336 |
| Sum | 432990.43 |
| Variance | 4980.8163 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 88.77 | 11 | 0.2% |
| 7.18 | 4 | 0.1% |
| 17.79 | 4 | 0.1% |
| 2.83 | 4 | 0.1% |
| 96.71 | 4 | 0.1% |
| 11.5 | 4 | 0.1% |
| 88.78 | 4 | 0.1% |
| 7.62 | 4 | 0.1% |
| 8.21 | 3 | 0.1% |
| 12.37 | 3 | 0.1% |
| Other values (4343) | 4965 |
| Value | Count | Frequency (%) |
| 0.01 | 1 | |
| 0.05 | 1 | |
| 0.06 | 1 | |
| 0.07 | 1 | |
| 0.09 | 1 | |
| 0.13 | 2 | |
| 0.14 | 2 | |
| 0.15 | 1 | |
| 0.17 | 1 | |
| 0.18 | 1 |
| Value | Count | Frequency (%) |
| 298.11 | 1 | |
| 296.11 | 1 | |
| 295.18 | 1 | |
| 295.08 | 1 | |
| 293.84 | 1 | |
| 293.28 | 1 | |
| 291.22 | 1 | |
| 290.07 | 1 | |
| 289.26 | 1 | |
| 289.11 | 1 |
NetAmount
Real number (ℝ)
High correlation 
| Distinct | 4999 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28765.104 |
| Minimum | 33.6 |
|---|---|
| Maximum | 99276.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 33.6 |
|---|---|
| 5-th percentile | 1497.0885 |
| Q1 | 8774.435 |
| median | 23424.75 |
| Q3 | 42886.6 |
| 95-th percentile | 75463.623 |
| Maximum | 99276.95 |
| Range | 99243.35 |
| Interquartile range (IQR) | 34112.165 |
Descriptive statistics
| Standard deviation | 23112.636 |
|---|---|
| Coefficient of variation (CV) | 0.80349563 |
| Kurtosis | -0.20322873 |
| Mean | 28765.104 |
| Median Absolute Deviation (MAD) | 16388.65 |
| Skewness | 0.78626283 |
| Sum | 1.4411317 × 108 |
| Variance | 5.3419393 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33542.82 | 11 | 0.2% |
| 33682.91 | 2 | < 0.1% |
| 48789.08 | 1 | < 0.1% |
| 53284.87 | 1 | < 0.1% |
| 25637.75 | 1 | < 0.1% |
| 2172.89 | 1 | < 0.1% |
| 22715.3 | 1 | < 0.1% |
| 39019.81 | 1 | < 0.1% |
| 6238.81 | 1 | < 0.1% |
| 19967.29 | 1 | < 0.1% |
| Other values (4989) | 4989 |
| Value | Count | Frequency (%) |
| 33.6 | 1 | |
| 57.81 | 1 | |
| 83.22 | 1 | |
| 125.11 | 1 | |
| 126.83 | 1 | |
| 128.04 | 1 | |
| 129.8 | 1 | |
| 175.81 | 1 | |
| 178.04 | 1 | |
| 183.97 | 1 |
| Value | Count | Frequency (%) |
| 99276.95 | 1 | |
| 99246.13 | 1 | |
| 98471.73 | 1 | |
| 98299.72 | 1 | |
| 97494.61 | 1 | |
| 97409.48 | 1 | |
| 96325.22 | 1 | |
| 96267.15 | 1 | |
| 95421.03 | 1 | |
| 95260.03 | 1 |
StockReceived
Real number (ℝ)
High correlation 
| Distinct | 451 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 277.07405 |
| Minimum | 50 |
|---|---|
| Maximum | 500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 72 |
| Q1 | 164 |
| median | 279 |
| Q3 | 393 |
| 95-th percentile | 478 |
| Maximum | 500 |
| Range | 450 |
| Interquartile range (IQR) | 229 |
Descriptive statistics
| Standard deviation | 130.3307 |
|---|---|
| Coefficient of variation (CV) | 0.47038218 |
| Kurtosis | -1.2123356 |
| Mean | 277.07405 |
| Median Absolute Deviation (MAD) | 115 |
| Skewness | -0.029436097 |
| Sum | 1388141 |
| Variance | 16986.091 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 347 | 23 | 0.5% |
| 290 | 23 | 0.5% |
| 401 | 22 | 0.4% |
| 258 | 21 | 0.4% |
| 143 | 21 | 0.4% |
| 341 | 21 | 0.4% |
| 185 | 21 | 0.4% |
| 464 | 21 | 0.4% |
| 430 | 20 | 0.4% |
| 281 | 20 | 0.4% |
| Other values (441) | 4797 |
| Value | Count | Frequency (%) |
| 50 | 11 | |
| 51 | 14 | |
| 52 | 6 | |
| 53 | 14 | |
| 54 | 6 | |
| 55 | 11 | |
| 56 | 4 | 0.1% |
| 57 | 13 | |
| 58 | 10 | |
| 59 | 8 |
| Value | Count | Frequency (%) |
| 500 | 20 | |
| 499 | 12 | |
| 498 | 5 | 0.1% |
| 497 | 7 | 0.1% |
| 496 | 19 | |
| 495 | 6 | 0.1% |
| 494 | 9 | |
| 493 | 9 | |
| 492 | 14 | |
| 491 | 13 |
StockSold
Real number (ℝ)
High correlation 
| Distinct | 461 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 139.11697 |
| Minimum | 1 |
|---|---|
| Maximum | 498 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 49 |
| median | 109 |
| Q3 | 209 |
| 95-th percentile | 362 |
| Maximum | 498 |
| Range | 497 |
| Interquartile range (IQR) | 160 |
Descriptive statistics
| Standard deviation | 111.01637 |
|---|---|
| Coefficient of variation (CV) | 0.79800741 |
| Kurtosis | -0.067428197 |
| Mean | 139.11697 |
| Median Absolute Deviation (MAD) | 71 |
| Skewness | 0.87581816 |
| Sum | 696976 |
| Variance | 12324.634 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 39 | 34 | 0.7% |
| 7 | 34 | 0.7% |
| 56 | 34 | 0.7% |
| 12 | 33 | 0.7% |
| 64 | 33 | 0.7% |
| 38 | 33 | 0.7% |
| 60 | 32 | 0.6% |
| 27 | 32 | 0.6% |
| 49 | 32 | 0.6% |
| 50 | 31 | 0.6% |
| Other values (451) | 4682 |
| Value | Count | Frequency (%) |
| 1 | 24 | |
| 2 | 22 | |
| 3 | 24 | |
| 4 | 22 | |
| 5 | 27 | |
| 6 | 25 | |
| 7 | 34 | |
| 8 | 24 | |
| 9 | 26 | |
| 10 | 24 |
| Value | Count | Frequency (%) |
| 498 | 1 | |
| 494 | 2 | |
| 493 | 1 | |
| 486 | 1 | |
| 485 | 2 | |
| 483 | 1 | |
| 482 | 1 | |
| 477 | 1 | |
| 473 | 2 | |
| 469 | 1 |
StockOnHand
Real number (ℝ)
High correlation 
| Distinct | 464 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 137.95709 |
| Minimum | 0 |
|---|---|
| Maximum | 490 |
| Zeros | 31 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 49 |
| median | 107 |
| Q3 | 206 |
| 95-th percentile | 359.55 |
| Maximum | 490 |
| Range | 490 |
| Interquartile range (IQR) | 157 |
Descriptive statistics
| Standard deviation | 110.36069 |
|---|---|
| Coefficient of variation (CV) | 0.79996393 |
| Kurtosis | -0.018666969 |
| Mean | 137.95709 |
| Median Absolute Deviation (MAD) | 70 |
| Skewness | 0.88968298 |
| Sum | 691165 |
| Variance | 12179.482 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 38 | 0.8% |
| 50 | 37 | 0.7% |
| 42 | 36 | 0.7% |
| 10 | 35 | 0.7% |
| 15 | 34 | 0.7% |
| 34 | 34 | 0.7% |
| 31 | 32 | 0.6% |
| 0 | 31 | 0.6% |
| 19 | 31 | 0.6% |
| 38 | 31 | 0.6% |
| Other values (454) | 4671 |
| Value | Count | Frequency (%) |
| 0 | 31 | |
| 1 | 26 | |
| 2 | 29 | |
| 3 | 20 | |
| 4 | 26 | |
| 5 | 22 | |
| 6 | 25 | |
| 7 | 22 | |
| 8 | 24 | |
| 9 | 28 |
| Value | Count | Frequency (%) |
| 490 | 1 | |
| 488 | 1 | |
| 484 | 1 | |
| 482 | 2 | |
| 481 | 2 | |
| 476 | 1 | |
| 474 | 1 | |
| 473 | 2 | |
| 470 | 1 | |
| 469 | 1 |
Interactions
Correlations
| CustomerSegment | DiscountAmount | NetAmount | ProductCategory | ProductName | ProductPrice | ProductSubCategory | QuantitySold | ShipperName | ShippingMethod | StockOnHand | StockReceived | StockSold | SupplierContact | SupplierLocation | SupplierName | TotalAmount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CustomerSegment | 1.000 | 0.016 | 0.032 | 0.014 | 0.024 | 0.053 | 0.036 | 0.000 | 0.019 | 0.000 | 0.000 | 0.000 | 0.021 | 0.036 | 0.031 | 0.031 | 0.033 |
| DiscountAmount | 0.016 | 1.000 | 0.413 | 0.228 | 0.280 | 0.264 | 0.251 | -0.008 | 0.000 | 0.019 | -0.004 | 0.007 | 0.013 | 0.017 | 0.007 | 0.007 | 0.417 |
| NetAmount | 0.032 | 0.413 | 1.000 | 0.222 | 0.279 | 0.263 | 0.250 | 0.696 | 0.000 | 0.039 | -0.008 | 0.007 | 0.015 | 0.000 | 0.000 | 0.000 | 1.000 |
| ProductCategory | 0.014 | 0.228 | 0.222 | 1.000 | 0.805 | 0.752 | 0.845 | 0.023 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.019 | 0.000 | 0.000 | 0.221 |
| ProductName | 0.024 | 0.280 | 0.279 | 0.805 | 1.000 | 0.828 | 0.952 | 0.021 | 0.000 | 0.034 | 0.010 | 0.000 | 0.016 | 0.011 | 0.001 | 0.001 | 0.279 |
| ProductPrice | 0.053 | 0.264 | 0.263 | 0.752 | 0.828 | 1.000 | 0.893 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 | 0.262 |
| ProductSubCategory | 0.036 | 0.251 | 0.250 | 0.845 | 0.952 | 0.893 | 1.000 | 0.013 | 0.000 | 0.010 | 0.000 | 0.000 | 0.019 | 0.010 | 0.000 | 0.000 | 0.250 |
| QuantitySold | 0.000 | -0.008 | 0.696 | 0.023 | 0.021 | 0.000 | 0.013 | 1.000 | 0.000 | 0.028 | -0.013 | -0.001 | 0.002 | 0.000 | 0.000 | 0.000 | 0.694 |
| ShipperName | 0.019 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.010 | 0.000 | 0.000 | 0.041 | 0.039 | 0.039 | 0.000 |
| ShippingMethod | 0.000 | 0.019 | 0.039 | 0.000 | 0.034 | 0.005 | 0.010 | 0.028 | 0.000 | 1.000 | 0.000 | 0.024 | 0.000 | 0.000 | 0.000 | 0.000 | 0.037 |
| StockOnHand | 0.000 | -0.004 | -0.008 | 0.000 | 0.010 | 0.000 | 0.000 | -0.013 | 0.010 | 0.000 | 1.000 | 0.561 | -0.255 | 0.013 | 0.002 | 0.002 | -0.008 |
| StockReceived | 0.000 | 0.007 | 0.007 | 0.000 | 0.000 | 0.000 | 0.000 | -0.001 | 0.000 | 0.024 | 0.561 | 1.000 | 0.572 | 0.000 | 0.000 | 0.000 | 0.007 |
| StockSold | 0.021 | 0.013 | 0.015 | 0.000 | 0.016 | 0.000 | 0.019 | 0.002 | 0.000 | 0.000 | -0.255 | 0.572 | 1.000 | 0.000 | 0.000 | 0.000 | 0.015 |
| SupplierContact | 0.036 | 0.017 | 0.000 | 0.019 | 0.011 | 0.007 | 0.010 | 0.000 | 0.041 | 0.000 | 0.013 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 |
| SupplierLocation | 0.031 | 0.007 | 0.000 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.039 | 0.000 | 0.002 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 |
| SupplierName | 0.031 | 0.007 | 0.000 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.039 | 0.000 | 0.002 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 |
| TotalAmount | 0.033 | 0.417 | 1.000 | 0.221 | 0.279 | 0.262 | 0.250 | 0.694 | 0.000 | 0.037 | -0.008 | 0.007 | 0.015 | 0.000 | 0.000 | 0.000 | 1.000 |
Missing values
Sample
| Date | ProductName | ProductCategory | ProductSubCategory | ProductPrice | CustomerName | CustomerEmail | CustomerAddress | CustomerPhone | CustomerSegment | SupplierName | SupplierLocation | SupplierContact | ShipperName | ShippingMethod | QuantitySold | TotalAmount | DiscountAmount | NetAmount | StockReceived | StockSold | StockOnHand | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-09-14 | Nathaniel | Electronics | Camera | 0.01 | Colleen Kelly | maryhurst@example.org | 354 Mcdowell Turnpike, Port Charles, CT 95318 | 908.610.2711x8507 | Silver | Rodriguez, Winters and Perez | Irwinhaven | 6538306661 | and Sons | Ground | 49 | 31965.15 | 121.07 | 31844.08 | 475 | 127 | 348 |
| 1 | 2023-02-11 | NonExistentProduct | Electronics | Mobile | 847.43 | Joel Wright | sandersvictoria@example.org | 24740 Fox Villages, New Tracie, MA 53038 | +1-408-938-0389x952 | Gold | Lawson-Wilkins | Calderonchester | NaN | PLC | Air | 73 | 61862.39 | 91.09 | 61771.30 | 487 | 243 | 244 |
| 2 | 2021-11-12 | Angela | InvalidCategory | Action Figures | 386.57 | Thomas Sawyer | ospence@example.net | 769 Joe Trail, East Terri, CA 43813 | 001-929-516-1919x39288 | Gold | Lee-Miller | South Emilyview | +1-588-750-7646 | PLC | Sea | 89 | 34404.73 | 10.56 | 34394.17 | 341 | 188 | 153 |
| 3 | 11-15-2021 | Amy | Home & Garden | Decor | 364.01 | Tyler Gardner | christopherjohnson@example.com | 27783 Olivia Centers, Williamsmouth, AL 09809 | 8907712983 | Gold | Soto-Rivera | West Denise | 805-650-6257x5876 | LLC | Air | 3 | 1092.03 | 69.06 | 1022.97 | 500 | 124 | 376 |
| 4 | 2023-04-22 | Nathaniel | Electronics | Camera | 652.35 | Meagan Peterson | epowell@example.net | 25357 Blackwell Locks, Andreabury, MH 27857 | 9999921886 | Gold | Rodriguez, Winters and Perez | Irwinhaven | 6538306661 | Ltd | Sea | 75 | 48926.25 | 137.17 | 48789.08 | 429 | 351 | 78 |
| 5 | 2022-12-08 | NonExistentProduct | Electronics | Mobile | 847.43 | Justin Hodge | NaN | PSC 1552, Box 7906, APO AP 50694 | 001-691-442-5371x97648 | Gold | Soto-Rivera | West Denise | 805-650-6257x5876 | Inc | Ground | 63 | 53388.09 | 103.22 | 53284.87 | 79 | 61 | 18 |
| 6 | 2023-09-13 | Justin | Electronics | Headphones | 66005.0 | Kelly Williams | philip97@example.com | 5881 Shawn Fords Apt. 256, Martinezbury, NH 01010 | 001-275-372-4620 | Silver | Soto-Rivera | West Denise | 805-650-6257x5876 | and Sons | Ground | 39 | 25741.95 | 104.20 | 25637.75 | 339 | 296 | 43 |
| 7 | 2023-07-19 | NonExistentProduct | Electronics | Camera | 652.35 | Natasha Thomas | rcole@example.org | 040 Lopez Crossing Apt. 758, Victormouth, RI 51198 | 998-812-6450x26711 | Silver | Campos-Murillo | Lawsontown | 822-222-4939 | Group | Ground | 60 | 39141.00 | 121.19 | 39019.81 | 305 | 53 | 252 |
| 8 | 2023-08-20 | Shannon | Home & Garden | Gardening Tools | 68.01 | Jessica Sanchez | NaN | 455 Mary Path, Cobbberg, PW 26662 | 972-968-0237x0312 | Gold | Wagner, Jackson and Holt | Port Sarahview | +1-362-752-2777x1817 | Inc | Air | 92 | 6256.92 | 18.11 | 6238.81 | 440 | 338 | 102 |
| 9 | 2023-07-15 | NonExistentProduct | Home & Garden | Decor | 364.01 | Nathan Good | NaN | 27534 Jennifer Burgs Suite 449, West Lauraville, AK 18548 | 322.403.9678x196 | Gold | White and Sons | West Scott | 288-572-7043 | PLC | Air | 55 | 20020.55 | 53.26 | 19967.29 | 260 | 254 | 6 |
| Date | ProductName | ProductCategory | ProductSubCategory | ProductPrice | CustomerName | CustomerEmail | CustomerAddress | CustomerPhone | CustomerSegment | SupplierName | SupplierLocation | SupplierContact | ShipperName | ShippingMethod | QuantitySold | TotalAmount | DiscountAmount | NetAmount | StockReceived | StockSold | StockOnHand | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5000 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5001 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5002 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5003 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5004 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5005 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5006 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5007 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5008 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
| 5009 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 |
Duplicate rows
Most frequently occurring
| Date | ProductName | ProductCategory | ProductSubCategory | ProductPrice | CustomerName | CustomerEmail | CustomerAddress | CustomerPhone | CustomerSegment | SupplierName | SupplierLocation | SupplierContact | ShipperName | ShippingMethod | QuantitySold | TotalAmount | DiscountAmount | NetAmount | StockReceived | StockSold | StockOnHand | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-08-24 | Angela | Toys | Action Figures | 386.57 | Bradley Smith | garciashawn@example.com | Unit 6079 Box 2184, DPO AP 21061 | (449)651-5198x65597 | Gold | Roman-Chambers | Dennischester | 001-324-909-1637x2831 | LLC | Ground | 87 | 33631.59 | 88.77 | 33542.82 | 401 | 359 | 42 | 11 |